So welcome to the end of the first class.
You have just finished the basics, kind of the entry, table stakes,
as it were. I've taught you perhaps many times CRUD,
create, read, update, and delete, join, data modeling. And I'm fond of saying that you just
learned the most important 60% of SQL. And so I've taught that material so
many times in so many different ways and to some of
you several times, and so there was always like, what was
the next topic that I wanted to cover? All right, what was the next one? And so there's been this whole set of
what would be the next topic and so that's what's in this next class. It's a grab bag of things
that I just couldn't fit into the first basic summary. Things like fancy dates, group by,
aggregate function like max and min and count, transactions,
subqueries, stored procedures, all kinds of cool operations like
with text and regular expressions and then moving into more advanced
indexing of text and material. So, it is a great class. And this is a set of techniques that we're
just kind of going to go through and say here's a technique,
here's a technique, here's a technique. And this is going to be some
really useful Postgres SQL. [MUSIC]